SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE PROCEDURE [dbo].[usp_UpdateEmail]

	(
	@param_id int,
	@param_topic VarChar(50),
	@param_recipients VarChar(MAX),
	@param_copy_to VarChar(MAX) ,
	@param_contents text,
	@param_sign VarChar(50),
	@param_mark VarChar(50),
	@param_update_time smalldatetime,
	@param_user_update VarChar(50),
	@param_send_state bit
	)

AS
	/* SET NOCOUNT ON */
	
	update dbo.JOL_EmailManagement_Email 
	set 
	 topic=@param_topic,
	 recipients=@param_recipients,
	 copy_to=@param_copy_to,
	 contents=@param_contents,
	 sign=@param_sign,
	 mark=@param_mark,
	 update_time=@param_update_time,
	 user_update=@param_user_update,
	 send_state=@param_send_state
	 where
	 id=@param_id
	 
	
	RETURN
GO
